2014-09-02 - 14160.100 - Spec - HANA Sizing #HANASizing
SPECIFICATIONS
14160.100 - Hana Sizing
Purpose
Need to delete PSA tables & Change log tables and to run scripts to get HANA expected sizing for budget reason.
Admin Info
Purpose
|
Need to delete PSA tables, Change log tables and to run scripts to get HANA expected sizing for budget reason.
|
Requested By
|
Abe Maritime
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
09/11/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
/SDF/HANA_BW_SIZING
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
08
|
2
|
Documentation
|
08
|
3
|
Development/Config
|
40
|
4
|
PSA Deletions
|
18
|
5
|
CL Deletions
|
06
|
6
|
Other activity
|
00
|
|
TOTAL
|
80
|
References
Prior Tickets
None
Documents
SAP_BW_on_HANA_Sizing_V1_8.pdf
BW on HANA Pulse Check How to collect statistics.pptx
Spec Changes
SNo.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
01
|
Execute HANA Sizing Program with & without PSA/CL deletions
|
Mark Harris
|
09/05/2014
|
Execute HANA Sizing Program before & after PSA and CL deletions.
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to Delete PSA tables, Change log tables and to run the scripts to get HANA expected sizing for budget reason.
In Scope:
Execute this program in BPD, BPQ and BPP only.
Out of Scope:
Other SAP systems like NECNED, NECNEQ and NEP.
Solution Summary
Need to execute the HANA Sizing program without deleting PSA's & Change log tables first and then again after deleting the PSA's & Change log tables in BPD(BW 7.3 Development), BPQ(BW 7.3 Quality) & BPP(BW 7.3 Production) Systems.
Solution Details
1. Need to execute the HANA Sizing program '/SDF/HANA_BW_SIZING' without deleting PSA's & Change log tables first and then again after deleting the PSA's & Change log tables in BPD(BW 7.3 Development). The List of Datasources & their Corresponding PSA tables, Change Log Tables to be deleted in BPD are attached here for reference:
Data Sources - BPD.xls
2. Need to execute the HANA Sizing program '/SDF/HANA_BW_SIZING' without deleting PSA's & Change log tables first and then again after deleting the PSA's & Change log tables in BPQ(BW 7.3 Quality).
The List of Datasources & their Corresponding PSA tables, Change Log Tables to be deleted in BPQ are attached here for reference:
Data Sources - BPQ.xls
Issues
Need to set the parameter '
rdisp/max_wprun_time' profile parameter in RZ11 to zero to prevent dialog processes from terminating due to time out conditions before executing the program.